﻿/*CREATE TABLE [dbo].[ApplicationBookOfWorkHistory2013] (
    [AccountLevel1]                 VARCHAR (25)     NULL,
    [AccountLevel2]                 VARCHAR (25)     NULL,
    [AccountLevel3]                 VARCHAR (25)     NULL,
    [InitiativeId]                  VARCHAR (30)     NULL,
    [InitiativeName]                VARCHAR (255)    NULL,
    [ProgramId]                     VARCHAR (30)     NULL,
    [ProgramName]                   VARCHAR (255)    NULL,
    [ProjectId]                     VARCHAR (10)     NULL,
    [ProjectName]                   VARCHAR (200)    NULL,
    [ProgramManager]                VARCHAR (255)    NULL,
    [ProgramStartDate]              DATETIME         NULL,
    [ProgramEndDate]                DATETIME         NULL,
    [ApplicationId]                 INT              NULL,
    [ApplicationName]               VARCHAR (150)    NULL,
    [ApplicationStatus]             CHAR (1)         NULL,
    [ProjectStatus]                 VARCHAR (100)    NULL,
    [ProjectStartDate]              DATETIME         NULL,
    [ProjectEndDate]                DATETIME         NULL,
    [ProjectManager]                VARCHAR (150)    NULL,
    [BillingClientGocCode]          VARCHAR (15)     NULL,
    [Client3Name]                   VARCHAR (120)    NULL,
    [Client4Name]                   VARCHAR (120)    NULL,
    [Client5Name]                   VARCHAR (120)    NULL,
    [Client6Name]                   VARCHAR (120)    NULL,
    [Client7Name]                   VARCHAR (120)    NULL,
    [Client8Name]                   VARCHAR (120)    NULL,
    [Client9Name]                   VARCHAR (120)    NULL,
    [Client10Name]                  VARCHAR (120)    NULL,
    [ClientGocCode]                 VARCHAR (15)     NULL,
    [ClientRegion]                  VARCHAR (64)     NULL,
    [System5Name]                   VARCHAR (120)    NULL,
    [System6Name]                   VARCHAR (120)    NULL,
    [System7Name]                   VARCHAR (120)    NULL,
    [System8Name]                   VARCHAR (120)    NULL,
    [System9Name]                   VARCHAR (120)    NULL,
    [System10Name]                  VARCHAR (120)    NULL,
    [SystemGOCCode]                 VARCHAR (15)     NULL,
    [SystemRegion]                  VARCHAR (64)     NULL,
    [LOB]                           VARCHAR (250)    NULL,
    [RuntheBankBuildtheBank]        VARCHAR (1)      NULL,
    [ProgramProjectLinkIndicator]   VARCHAR (10)     NULL,
    [WorkTypeFinancials]            VARCHAR (18)     NULL,
    [InitiativeInvestimentCategory] VARCHAR (186)    NULL,
    [ProgramInvestimentCategory]    VARCHAR (50)     NULL,
    [ProgramCapitalizedIndicator]   CHAR (1)         NULL,
    [ProgramStatus]                 VARCHAR (50)     NULL,
    [ProjectCapitalization]         CHAR (1)         NULL,
    [BowFlag]                       VARCHAR (10)     NULL,
    [BowFlag2]                      VARCHAR (10)     NULL,
    [ProjectType]                   VARCHAR (100)    NULL,
    [ProgramCarryoverIndicator]     CHAR (1)         NULL,
    [TaxonomyName]                  VARCHAR (100)    NULL,
    [CURate]                        DECIMAL (9, 6)   NULL,
    [FirstOfProgramDesc]            VARCHAR (2000)   NULL,
    [AdjustedFlag]                  VARCHAR (10)     NULL,
    [LobParent]                     VARCHAR (250)    NULL,
    [January]                       DECIMAL (38, 18) NULL,
    [February]                      DECIMAL (38, 18) NULL,
    [March]                         DECIMAL (38, 18) NULL,
    [April]                         DECIMAL (38, 18) NULL,
    [May]                           DECIMAL (38, 18) NULL,
    [June]                          DECIMAL (38, 18) NULL,
    [July]                          DECIMAL (38, 18) NULL,
    [August]                        DECIMAL (38, 18) NULL,
    [September]                     DECIMAL (38, 18) NULL,
    [October]                       DECIMAL (38, 18) NULL,
    [November]                      DECIMAL (38, 18) NULL,
    [December]                      DECIMAL (38, 18) NULL,
    [YearToDate]                    DECIMAL (38, 18) NULL,
    [FullYear]                      DECIMAL (38, 18) NULL,
    [ReferenceDate]                 DATE             DEFAULT (getdate()) NOT NULL,
    [LastUpdate]                    DATETIME         DEFAULT (getdate()) NOT NULL
);*/

